RowFilter including [ character in search string

Posted by JeffC on Stack Overflow See other posts from Stack Overflow or by JeffC
Published on 2010-04-05T18:58:00Z Indexed on 2010/04/06 3:43 UTC
Read the original article Hit count: 413

Filed under:

ADO.NET

|

rowfilter

I fill a DataSet and allow the user to enter a search string. Instead of hitting the database again, I set the RowFilter to display the selected data. When the user enters a square bracket ( "[" ) I get an error "Error in Like Operator". I know there is a list of characters that need prefixed with "\" when they are used in a field name, but how do I prevent RowFilter from interpreting "[" as the beginning of a column name?

© Stack Overflow or respective owner

Related posts about ADO.NET

Asp.net ADO.NET Entity Framework or ADO.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server. The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data. I have previously created projects with Linq-To-Sql or with Ado.Net. My plan for this project is to use VS2010… >>> More
ADO.NET Entity Framework or ADO.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server. The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data. I have previously created projects with Linq-To-Sql or with Ado.Net. My plan for this project is to use VS2010… >>> More
RIA Services vs ADO.NET Data Services

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently in the process of creating a Silverlight 3 data driven application. To access the database, 2 common approaches are used: RIA Services and ADO.NET Data Services. Does anyone have any guidance on when/why to choose each approach? Here is what I've gathered from my research / experience… >>> More
Ado.net dataservices BeginExecuteBatch call works on development fails on production server with Obj

as seen on Stack Overflow - Search for 'Stack Overflow'
We have an ado.net dataservices 1.0 call that is being passed to a [WebGet] service operation as a batch through BeginExecuteBatch. Everything works perfectly on our development server - we have the project configured to use IIS instead of the cassini web server to make it as close to our production… >>> More
ADO.Net : Get table definition from SQL server tables

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using C# to write a method that returns the following information about a table: column names, column types, column sizes, foreign keys. Can someone point me in the right direction on how to accomplish this ? >>> More

Related posts about rowfilter

RowFilter including [ character in search string

as seen on Stack Overflow - Search for 'Stack Overflow'
I fill a DataSet and allow the user to enter a search string. Instead of hitting the database again, I set the RowFilter to display the selected data. When the user enters a square bracket ( "[" ) I get an error "Error in Like Operator". I know there is a list of characters that need prefixed with… >>> More
RowFilter.regexFilter multiple columns

as seen on Stack Overflow - Search for 'Stack Overflow'
I am currently using the following to filter my JTable RowFilter.regexFilter( Pattern.compile(textField.getText(), Pattern.CASE_INSENSITIVE).toString(), columns ); How do I format my textField or filter so if I want to filter multiple columns I can do that. Right now I can… >>> More
DataView.RowFilter an ISO8601

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a DataTable (instance named: TimeTable) whose DefaultView (instance named: TimeTableView) I am trying to use to filter based on a date. Column clock_in contains an ISO8601 formatted string. I would like to select all the rows in this DataTable/DefaultView between 2009-10-08T08:22:02Z and 2009-10-08T20:22:02Z… >>> More
Filtering by date with DataTable.RowFilter while ignoring time

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I filter for records on a DataTable which are on a certain date? I've tried plain [datecol] = #11 March 2010# and CONVERT([datecol],'System.DateTime') = #11 March 2010#. With no luck. MSDN: RowFilter Expression Syntax Solution [datecol] >= #11 March 2010 00:00# AND [datecol] <= #11… >>> More
How can I filter a JTable?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to filter a JTable, but I don't understand how I can do it. I have read How to Use Tables - Sorting and Filtering and I have tried with the code below, but with that filter, no rows at all is shown in my table. And I don't understand what column it is filtered on. private void myFilter()… >>> More